/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 26727
 * Date: 2024-11-08
 * Time: 23:20
 */
public class Solution13 {
//    select a.product_id,ifnull(b.new_price,10) price from
//(select distinct product_id from Products) a left join
//            (select product_id,new_price from Products where (product_id,change_date) in
//(select distinct product_id,max(change_date) from Products where
//    change_date <= '2019-08-16' group by product_id)) b
//    on a.product_id = b.product_id
}
